CREATE TABLE [SSB].[PSMar7]
(
[Report Date] [datetime] NULL,
[Security Name/Description] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset ID] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund ID] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local Currency] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Transaction Type] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Shares/Par] [decimal] (38, 10) NULL,
[Price (Base)] [decimal] (38, 10) NULL,
[Net Amount (Base)] [decimal] (38, 10) NULL,
[ID Cost Base - Buy Lot] [decimal] (38, 10) NULL,
[Trade Date] [datetime] NULL,
[Contractual Settle Date] [datetime] NULL,
[Actual Settlement Date] [datetime] NULL,
[Settlement Status] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker Number] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SSC Trade ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Trade ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Original Trade ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account Number] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lot Number] [decimal] (38, 10) NULL,
[Account Number - Buy Lot] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Post Date] [datetime] NULL,
[Cancel Reason Code] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Report Date] [datetime] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20140314-032238] ON [SSB].[PSMar7] ([Report Date]) INCLUDE ([Account Number], [Account Number - Buy Lot], [Actual Settlement Date], [Asset ID], [Broker], [Broker Number], [Cancel Post Date], [Cancel Reason Code], [Cancel Report Date], [Cancel Trade ID], [Contractual Settle Date], [Fund ID], [ID Cost Base - Buy Lot], [Local Currency], [Lot Number], [Net Amount (Base)], [Original Trade ID], [Price (Base)], [Security Name/Description], [Settlement Status], [Shares/Par], [SSC Trade ID], [Trade Date], [Transaction Type]) ON [PRIMARY]
GO
